USE test
GO


INSERT INTO dbo.[User](name,
	    jointime,
	    account,
	    pwd)
SELECT name = 'n1',
	    jointime = GETDATE(),
	    account = 'n1',
	    pwd = 0x12
UNION ALL
SELECT name = 'n2',
	    jointime = GETDATE(),
	    account = 'n2',
	    pwd = 0x13
UNION ALL
SELECT name = 'n3',
	    jointime = GETDATE(),
	    account = 'n3',
	    pwd = 0x13		
GO
 
INSERT INTO dbo.Blog(title,
	[body],
	authoruid,
	documentType,
	pubDate,
	editDate)
SELECT title = 't1',
	[body] = 'body1',
	authoruid = 1,
	documentType = 1,
	pubDate = GETDATE(),
	editDate = GETDATE()	
UNION ALL
SELECT title = 't2',
	[body] = 'body2',
	authoruid = 1,
	documentType = 1,
	pubDate = GETDATE(),
	editDate = GETDATE()
UNION ALL
SELECT title = 't3',
	[body] = 'body3',
	authoruid = 2,
	documentType = 1,
	pubDate = GETDATE(),
	editDate = GETDATE()
UNION ALL
SELECT title = 't4',
	[body] = 'body4',
	authoruid = 2,
	documentType = 1,
	pubDate = GETDATE(),
	editDate = GETDATE()	